package com.kehutong.charge.vo;

import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.*;
import com.kehutong.common.util.DateUtil;
import org.apache.poi.ss.usermodel.HorizontalAlignment;

import java.sql.Timestamp;

/**
 * @description: 抄表模板导出
 * @author: jian Ye
 * @create: 2021/8/23
 **/
@ExcelIgnoreUnannotated
@HeadRowHeight(50)
@HeadStyle(horizontalAlignment = HorizontalAlignment.LEFT)
@ContentFontStyle(fontHeightInPoints = 12)
@HeadFontStyle(fontHeightInPoints = 12,color = 10,bold = false)
public class ReadingMeterTemplateExcelBaseVO {

    protected final static String BIG_TITLE =
            "填写须知（本行和表头行勿删除）：\n" +
            "(1)以下红色字体为必填项，黑色字体为选填；\n" +
            "(2)本次读数中只需填写抄表的数字无需填写单位；\n" +
            "(3)收费用户手机号码：仅支持国内11位手机号；\n";



    @ColumnWidth(30)
    @ExcelProperty(index = 0,value = {BIG_TITLE,"仪表编号"})
    private String meterNo;

    @ColumnWidth(15)
    @ExcelProperty(index = 1,value = {BIG_TITLE,"仪表类型"})
    private String meterTypeName;

    @ColumnWidth(15)
    @HeadFontStyle(fontHeightInPoints = 12,color = 8,bold = false)
    @ExcelProperty(index = 2,value = {BIG_TITLE,"仪表分类"})
    private String meterClassifyName;

    @ColumnWidth(20)
    @ExcelProperty(index = 3,value = {BIG_TITLE,"项目/小区名称"})
    private String communityName;

    @ColumnWidth(10)
    @ExcelProperty(index = 4,value = {BIG_TITLE,"楼栋"})
    private String buildName;

    @ColumnWidth(10)
    @HeadFontStyle(fontHeightInPoints = 12,color = 8,bold = false)
    @ExcelProperty(index = 5,value = {BIG_TITLE,"单元"})
    private String unitName;

    @ColumnWidth(10)
    @ExcelProperty(index = 6,value = {BIG_TITLE,"房号"})
    private String houseNumber;

    @ColumnWidth(10)
    @HeadFontStyle(fontHeightInPoints = 12,color = 8,bold = false)
    @ExcelProperty(index = 7,value = {BIG_TITLE,"客户"})
    private String chargeName;

    @ColumnWidth(20)
    @HeadFontStyle(fontHeightInPoints = 12,color = 8,bold = false)
    @ExcelProperty(index = 8,value = {BIG_TITLE,"客户手机号码"})
    private String chargePhone;

    private String timeNumber;

    @ColumnWidth(20)
    @ExcelProperty(index = 10,value = {BIG_TITLE,"抄表日期"})
    private String createTime;

    @ColumnWidth(10)
    @ExcelProperty(index = 11,value = {BIG_TITLE,"抄表人"})
    private String createName;

    private String startTime;

    private String endTime;

    private String houseNo;


    public String getMeterNo() {
        return meterNo;
    }

    public void setMeterNo(String meterNo) {
        this.meterNo = meterNo;
    }

    public String getMeterTypeName() {
        return meterTypeName;
    }

    public void setMeterTypeName(String meterTypeName) {
        this.meterTypeName = meterTypeName;
    }

    public String getMeterClassifyName() {
        return meterClassifyName;
    }

    public void setMeterClassifyName(String meterClassifyName) {
        this.meterClassifyName = meterClassifyName;
    }

    public String getCommunityName() {
        return communityName;
    }

    public void setCommunityName(String communityName) {
        this.communityName = communityName;
    }

    public String getBuildName() {
        return buildName;
    }

    public void setBuildName(String buildName) {
        this.buildName = buildName;
    }

    public String getUnitName() {
        return unitName;
    }

    public void setUnitName(String unitName) {
        this.unitName = unitName;
    }

    public String getHouseNumber() {
        return houseNumber;
    }

    public void setHouseNumber(String houseNumber) {
        this.houseNumber = houseNumber;
    }

    public String getChargeName() {
        return chargeName;
    }

    public void setChargeName(String chargeName) {
        this.chargeName = chargeName;
    }

    public String getChargePhone() {
        return chargePhone;
    }

    public void setChargePhone(String chargePhone) {
        this.chargePhone = chargePhone;
    }

    public String getTimeNumber() {
        return timeNumber;
    }

    public void setTimeNumber(String timeNumber) {
        this.timeNumber = timeNumber;
    }

    public String getCreateTime() {
        return createTime;
    }

    public void setCreateTime(String createTime) {
        this.createTime = createTime;
    }

    public String getCreateName() {
        return createName;
    }

    public void setCreateName(String createName) {
        this.createName = createName;
    }

    public String getStartTime() {
        return startTime;
    }

    public void setStartTime(String startTime) {
        this.startTime = startTime;
    }

    public String getEndTime() {
        return endTime;
    }

    public void setEndTime(String endTime) {
        this.endTime = endTime;
    }

    public String getHouseNo() {
        return houseNo;
    }

    public void setHouseNo(String houseNo) {
        this.houseNo = houseNo;
    }
}
